IF exists(SELECT * FROM dbo.sysobjects WHERE name='WEB_klassen' AND xtype='P') 
BEGIN
	DROP PROCEDURE WEB_klassen
END
GO

CREATE   procedure WEB_klassen
as
set nocount on

select '0AAAA' as klas,'<?xml version="1.0"  encoding="ISO-8859-1" ?><klassen>' as tekst
union
select klas,'<klas>' + isNull(klas,'') + '</klas>'
from vertaalTabelKlas
where not klas like '%weg%'
union
select 'ZZZZZ','</klassen>'
order by klas